/BCO-DMO/Lionfish_Invasion/lionfish_effects_on_grazing --substrate_type eq pavement/sand_with_bommies-- Level 1
# Effects of lionfish on grazing
# (From sub-project "Effects of lionfish on grazing by herbivorousOSU)
# Sub-Project : Mark Hixon (OSU)
# Sub-Project Lead: Tye Kindinger (OSU)
# Version: 16 Aug 2013
=========================
date site lat lon area depth_min depth_max reef_pair_code nearest tidal_chan ex_sound substrate_type site_treatment
-------------------------
07/22/2011 Tug_and_Barge 23.75208 -76.10603 3230 2 3 D 1550 1200 4650 pavement/sand_with_bommies Low
=========================
replicate treatment ledge_pair ledge_treatment filmed obs_time algal_pcnt_init algal_pcnt_final algal_loss fish_count_tot bites_tot prey_tot prey_bites_tot adult_tot adult_bites_tot graze_rate
-------------------------
1 CTRL 1 Absent Y 60 84.5314668 59.49023541 25.0412314 39 573 13 413 26 160 9.55
2 CTRL 1 Absent Y 60 75.0311379 57.87874437 17.1523935 56 319 5 50 51 269 5.316666667
3 CTRL 2 Absent N 20 54.1763912 52.30707807 1.8693132 8 321 0 0 8 321 16.05
4 CTRL 3 Absent N 20 64.3532354 56.74429581 7.6089396 7 121 3 80 4 41 6.05
5 CTRL 2 Absent N 20 65.4142086 54.59343337 10.8207752 6 34 2 4 4 30 1.7
6 CTRL 3 Absent N 20 58.7351444 44.20158942 14.533555 5 99 2 3 3 4 4.95
7 CTRL 4 Absent N 20 56.9138448 55.82242257 1.0914222 7 81 5 73 2 8 4.05
8 CTRL 4 Absent N 20 49.1982576 41.82355714 7.3747004 2 16 1 3 1 13 0.8
9 CTRL 5 Absent N 20 56.8217906 44.63933897 12.1824517 5 41 2 12 3 29 2.05
10 CTRL 6 Absent N 20 60.1963387 49.76199302 10.4343457 3 33 1 29 2 4 1.65
11 CTRL 7 Absent Y 60 60.455292 46.25267857 14.2026134 17 170 15 162 2 8 2.833333333
12 CTRL 7 Absent Y 60 71.8211318 67.08196335 4.7391684 15 177 1 62 14 115 2.95
13 CTRL 8 Absent N 20 71.9383141 66.71071941 5.2275947 8 69 7 65 1 4 3.45
14 CTRL 9 Absent N 20 60.5536692 49.34969934 11.2039698 2 42 2 42 0 0 2.1
15 CTRL 5 Absent N 20 54.520905 38.64098985 15.8799152 11 109 10 57 1 52 5.45
16 CTRL 9 Absent N 20 53.8363829 46.12764199 7.7087409 3 33 1 4 2 29 1.65
17 CTRL 8 Absent N 20 65.7706973 51.39081434 14.379883 3 78 1 39 2 39 3.9
18 CTRL 6 Absent N 20 74.1873014 56.74752057 17.4397808 6 127 0 0 6 127 6.35
19 CTRL 10 Absent N 20 62.2608045 54.25559794 8.0052065 6 111 3 7 3 104 5.55
20 CTRL 10 Absent N 20 54.5716526 53.94629331 0.6253592 2 72 2 72 0 0 3.6
=========================
date site lat lon area depth_min depth_max reef_pair_code nearest tidal_chan ex_sound substrate_type site_treatment
-------------------------
07/23/2011 Shark_Rocks 23.75058 -76.12519 3030 2 3 D 1050 1000 4590 pavement/sand_with_bommies High
=========================
replicate treatment ledge_pair ledge_treatment filmed obs_time algal_pcnt_init algal_pcnt_final algal_loss fish_count_tot bites_tot prey_tot prey_bites_tot adult_tot adult_bites_tot graze_rate
-------------------------
1 LABS 11 Absent Y 60 55.9322632 49.47149434 6.4607688 3 15 2 3 1 12 0.25
2 LPRS 11 Present Y 60 54.2215144 45.4059667 8.8155477 2 54 0 0 2 54 0.9
3 LABS 12 Absent N 20 59.4692426 48.96766035 10.5015823 1 16 1 16 0 0 0.8
4 LABS 13 Absent N 20 63.6727201 63.24681484 0.4259052 8 148 0 0 8 148 7.4
5 LPRS 14 Present N 20 61.2909004 44.04252883 17.2483716 1 6 1 6 0 0 0.3
6 LABS 14 Absent N 20 50.3019739 49.37702447 0.9249494 1 60 0 0 1 60 3
7 LPRS 15 Present N 20 65.7569147 57.45984829 8.2970664 8 38 7 35 1 3 1.9
8 LABS 15 Absent N 20 49.747671 49.41368151 0.3339895 3 26 3 26 0 0 1.3
9 LPRS 13 Present N 20 56.4131973 48.2748703 8.138327 3 31 2 26 1 5 1.55
10 LABS 16 Absent N 20 49.7329134 44.05062823 5.6822851 0 0 0 0 0 0 0
11 LABS 17 Absent Y 60 65.4627409 57.35745609 8.1052848 8 25 1 2 7 23 0.416666667
12 LPRS 17 Present Y 60 54.3662298 50.38019802 3.9860318 2 51 1 6 1 45 0.85
13 LABS 18 Absent N 20 65.5065879 49.36132228 16.1452656 1 30 1 30 0 0 1.5
14 LPRS 12 Present N 20 58.5648888 56.23962247 2.3252663 0 0 0 0 0 0 0
15 LPRS 18 Present N 20 63.4668935 54.9725196 8.4943739 0 0 0 0 0 0 0
16 LPRS 16 Present N 20 64.950514 54.95422666 9.9962873 0 0 0 0 0 0 0
17 LPRS 19 Present N 20 64.2483499 63.09846031 1.1498896 2 34 0 0 2 34 1.7
18 LPRS 20 Present N 20 63.6483309 54.92078342 8.7275475 0 0 0 0 0 0 0
19 LABS 19 Absent N 20 65.8169049 59.3721024 6.4448025 4 128 3 125 1 3 6.4
20 LABS 20 Absent N 20 65.7973922 63.75160327 2.0457889 1 59 1 59 0 0 2.95
=========================
date site lat lon area depth_min depth_max reef_pair_code nearest tidal_chan ex_sound substrate_type site_treatment
-------------------------
07/24/2011 Square_Rock 23.71799 -76.02326 2640 2 7 C 90 190 460 pavement/sand_with_bommies Low
=========================
replicate treatment ledge_pair ledge_treatment filmed obs_time algal_pcnt_init algal_pcnt_final algal_loss fish_count_tot bites_tot prey_tot prey_bites_tot adult_tot adult_bites_tot graze_rate
-------------------------
1 CTRL 21 Absent Y 60 53.715197 46.14876156 7.5664355 0 0 0 0 0 0 0
2 CTRL 21 Absent Y 60 55.0724479 48.51053216 6.5619158 7 122 6 73 1 49 2.033333333
3 CTRL 22 Absent N 20 58.9413403 48.26961707 10.6717232 5 192 2 23 3 79 9.6
4 CTRL 23 Absent N 20 51.5539121 49.15283785 2.4010743 6 113 3 28 3 175 5.65
5 CTRL 24 Absent N 20 55.3263196 53.98555841 1.3407612 5 44 4 26 1 18 2.2
6 CTRL 24 Absent N 20 59.3721951 45.96713769 13.4050575 8 94 7 56 1 38 4.7
7 CTRL 23 Absent N 20 66.7880835 46.45082534 20.3372582 4 155 0 0 4 155 7.75
8 CTRL 22 Absent N 20 60.8275222 39.20374789 21.6237743 5 140 0 0 5 140 7
9 CTRL 25 Absent N 20 50.1798615 39.78198854 10.397873 1 2 1 2 0 0 0.1
10 CTRL 25 Absent N 20 51.7774266 51.03576572 0.7416609 2 13 0 0 2 13 0.65
11 CTRL 26 Absent Y 60 62.0832344 51.36290211 10.7203323 4 13 2 8 2 5 0.216666667
12 CTRL 26 Absent Y 60 86.4262144 63.16845424 23.2577601 8 41 0 0 8 41 0.683333333
13 CTRL 27 Absent N 20 67.1058241 62.61013546 4.4956887 15 138 15 138 0 0 6.9
14 CTRL 27 Absent N 20 75.4185547 59.37556968 16.042985 3 29 2 19 1 10 1.45
15 CTRL 28 Absent N 20 73.6933163 58.33458289 15.3587334 1 1 0 0 1 1 0.05
16 CTRL 28 Absent N 20 65.8280844 54.95845033 10.869634 2 5 2 5 0 0 0.25
17 CTRL 29 Absent N 20 60.1871661 49.28422773 10.9029384 1 4 0 0 1 4 0.2
18 CTRL 30 Absent N 20 86.9822847 62.93316625 24.0491185 4 25 0 0 4 25 1.25
19 CTRL 29 Absent N 20 45.1607594 43.4981692 1.6625902 1 18 1 18 0 0 0.9
20 CTRL 30 Absent N 20 63.8017915 54.47538316 9.3264083 2 52 1 40 1 12 2.6
=========================
date site lat lon area depth_min depth_max reef_pair_code nearest tidal_chan ex_sound substrate_type site_treatment
-------------------------
07/25/2011 Woobie_Rock 23.81761 -76.18875 3180 2 7 C 215 0 1660 pavement/sand_with_bommies High
=========================
replicate treatment ledge_pair ledge_treatment filmed obs_time algal_pcnt_init algal_pcnt_final algal_loss fish_count_tot bites_tot prey_tot prey_bites_tot adult_tot adult_bites_tot graze_rate
-------------------------
1 LPRS 31 Present Y 60 61.5505327 50.85547643 10.6950562 0 0 0 0 0 0 0
2 LABS 31 Absent Y 60 67.3709998 58.87886477 8.4921351 2 41 0 0 2 3 0.683333333
3 LPRS 32 Present N 20 95.6474745 92.50774615 3.1397283 0 0 0 0 0 0 0
4 LABS 32 Absent N 20 60.4026341 56.43398112 3.968653 1 49 0 0 1 49 2.45
5 LPRS 33 Present N 20 75.7506026 51.9867138 23.7638888 0 0 0 0 0 0 0
6 LABS 33 Absent N 20 78.8832143 76.24305354 2.6401607 2 16 2 16 0 0 0.8
7 LPRS 34 Present N 20 47.0621292 46.36121185 0.7009173 2 6 0 0 2 6 0.3
8 LABS 34 Absent N 20 73.2092338 66.07707727 7.1321565 5 102 5 102 0 0 5.1
9 LPRS 35 Present N 20 67.2049761 60.83283656 6.3721395 1 15 1 15 0 0 0.75
10 LABS 35 Absent N 20 77.221381 65.67486613 11.5465148 4 32 3 20 1 12 1.6
11 LABS 36 Absent Y 60 67.5979629 59.39309344 8.2048695 0 0 0 0 0 0 0
12 LPRS 36 Present Y 60 75.6124784 69.6372357 5.9752427 0 0 0 0 0 0 0
13 LPRS 37 Present N 20 61.9485913 59.98435441 1.9642369 0 0 0 0 0 0 0
14 LPRS 38 Present N 20 57.9916022 57.55716985 0.4344324 0 0 0 0 0 0 0
15 LABS 37 Absent N 20 66.8676616 62.82511106 4.0425505 2 68 1 60 1 8 3.4
16 LABS 38 Absent N 20 60.3430651 48.9966687 11.3463964 0 0 0 0 0 0 0
17 LPRS 39 Present N 20 52.4448737 52.20110657 0.2437671 0 0 0 0 0 0 0
18 LABS 39 Absent N 20 65.0439025 57.51645221 7.5274503 2 57 2 57 0 0 2.85
19 LPRS 40 Present N 20 63.7467151 53.19372068 10.5529944 0 0 0 0 0 0 0
20 LABS 40 Absent N 20 58.1807012 54.7351443 3.4455569 1 27 0 0 1 27 1.35